SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 7328 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 7328 [ RunTime:0.002288s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (243275,1036838,225508,246160,511527,666843,52151,1018703,516297,508988,235615,471764,840768,509044,413543,575218,868376,314944,749182,493121,938680,16084,948702,746474,789897,1014230,305628,360951,604911,96931,722769,440864,755524,93907,376485,37659,784018,324711,207479,88717,38156,553484,303145,695680,850837,924603,289093,250665,1011104,194657,600706,789381,266936,272103,88893,943064,543140,460243,98733,205225) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 7328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 7328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]