SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453800 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453800 [ RunTime:0.005633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (565434,954593,745260,299019,1027163,312066,296079,28712,542704,1029892,731259,486173,482313,817353,401832,340668,818695,462765,203710,317341,683191,371666,95718,970531,346075,530905,635731,363614,388348,332606,251660,607720,1022242,582807,1031908,829773,531336,539814,140308,386212,224930,104076,930749,1002880,754935,224320,937948,789156,97792,1021766,487492,834378,623781,145594,568696,399472,85590,223835,615909,128722) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000857s ]