SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001806s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511151 LIMIT 1 [ RunTime:0.000706s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511151 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (558847,534197,490595,955322,97040,713245,887890,371338,537884,47705,174081,24882,751168,975239,257662,983480,1031937,1048479,975022,616161,475149,844154,1026890,1023876,368173,542521,273140,766110,269682,444546,1033902,941676,967609,301897,562885,25746,128470,322559,680434,389119,389383,860586,321671,28450,680681,696095,278561,196177,541045,380808,456885,921551,770469,73824,778684,402430,275757,533187,888739,551113) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001043s ]