SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432166 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432166 [ RunTime:0.002298s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (627132,436934,159500,97463,600990,207969,447715,1022958,654876,610973,141596,156983,1039524,825402,350760,344143,103081,292215,1006786,542171,531432,89592,848647,704934,934562,432516,677405,428842,136036,8430,580971,278010,661609,334266,358141,375114,891133,838690,234627,504856,731142,611275,845767,790297,427231,451665,754540,638444,266310,129700,25931,259125,633501,1031251,418958,11938,212895,249692,913614,671170) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432166 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432166 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]