SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80130 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80130 [ RunTime:0.001969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (61292,438094,1010387,1042089,572815,869320,39936,1016323,234481,230832,1004600,769168,696962,859949,569746,92933,437686,58975,271038,122373,14760,172360,188832,805485,343909,157839,631192,1038039,509356,132518,108905,670898,672814,383353,741282,394664,466568,38335,644442,784689,128407,650007,749631,758135,95586,902608,278110,821335,95521,972418,737285,444191,860604,534899,775535,581471,834882,196218,834787,526991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001687s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80130 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80130 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]