SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001536s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110500 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110500 [ RunTime:0.001665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (733394,668187,369921,900724,498243,224175,723119,289740,953044,390901,837512,278059,995402,302133,280601,64179,1048381,322855,226852,138620,60158,395996,734598,895669,714778,1028684,264891,1026804,661959,668928,235239,465706,726531,120689,805081,488748,816059,390555,615393,636685,951273,503314,296209,503578,378673,195076,587657,523139,490367,268513,992223,706260,825470,799037,610192,893443,20192,411229,949616,698254) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]