SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001999s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 26554 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 26554 [ RunTime:0.001777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480508,14045,173530,601256,308287,725771,796476,844885,51417,574115,418941,584280,855162,705644,840385,642618,990041,318403,89711,1036156,406523,840086,194191,46333,488274,745793,131437,222007,440588,861937,702778,4528,733009,532149,1031139,44534,944215,363988,312951,52918,1030257,950580,70351,250548,998549,783429,126195,973592,852132,580406,576142,779843,643559,49820,916941,146988,369805,839876,450783,822265) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 26554 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 26554 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]