SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001680s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515079 LIMIT 1 [ RunTime:0.000722s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515079 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (961918,471877,23805,545584,712452,986580,647781,465025,252238,639340,955581,133665,849735,843632,453107,435431,227532,576227,312450,680218,744786,292959,1010289,766547,577710,806089,455063,845074,113265,21652,483085,158966,513913,264646,437776,140142,1029485,586933,204816,957474,904937,650057,274710,714558,907419,955103,771186,397786,389608,390172,432445,783052,172284,339221,35562,488654,734157,751460,559905,875699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515079 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515079 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]