SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336591 LIMIT 1 [ RunTime:0.001012s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336591 [ RunTime:0.004062s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532019,701273,188116,1045599,675285,711341,716813,231498,889489,973240,33235,961562,323528,874208,250038,11661,335187,120583,454014,493775,874959,973392,17544,876712,938450,832314,844690,336805,178079,787403,82792,784873,375183,613238,571408,409042,148762,131834,656974,999671,285064,980545,244501,250878,700448,704188,330250,903746,29823,117055,550537,817339,855850,846263,645944,121776,557961,652190,676550,894497) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000757s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]