SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486164 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486164 [ RunTime:0.002260s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (484941,101614,752320,64664,710647,532534,345185,931034,539315,478636,754027,767833,497261,683364,652916,295072,785266,146565,973559,74810,140293,725657,808938,472897,393479,870655,168311,710255,895448,876310,1033786,339719,1047500,322683,40030,258650,312375,620576,421582,958412,559058,864671,167842,287386,164234,273245,731278,843076,555154,424699,626179,160292,146943,180468,408717,743893,176064,318702,966558,276996) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486164 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486164 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]