SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002540s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44787 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44787 [ RunTime:0.003105s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140852,1040281,7084,287728,12393,128540,226901,426701,389829,740661,559263,987133,319710,810913,893249,907347,287437,732168,161832,444075,416144,957217,470676,207944,892840,120847,435560,777324,445004,923246,103853,156372,982467,731714,102637,901118,750538,508762,934695,279859,392463,192323,272611,967868,169030,336122,676060,858938,140151,35886,1019086,130610,45789,672539,318359,810456,1021437,829490,985523,371846) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44787 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44787 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004512s ]