SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533492 LIMIT 1 [ RunTime:0.001589s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533492 [ RunTime:0.001816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (617733,669967,703357,458081,905000,142616,116831,545081,406076,870586,954057,237095,523745,187553,218199,965372,413622,452703,2220,919531,751351,238448,594877,190388,323655,965474,392132,185136,316561,586990,141179,463392,354488,302438,815991,21411,269242,294255,828141,606074,621109,48856,4650,376023,447075,1042286,170734,612123,986059,127011,735497,555646,410817,462651,917334,724311,499442,902547,998116,782201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533492 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533492 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]