SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 603211 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 603211 [ RunTime:0.001851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801116,489835,503852,577390,437458,1009597,853269,457588,641394,404992,744230,204901,472898,244064,724384,67268,437700,123704,179949,146557,476838,701610,842699,959772,814041,129682,679994,131131,354656,229871,937174,1025875,709239,919779,321409,576099,599971,275991,746633,99095,801217,648226,485758,642170,992315,423877,984160,294173,625763,8161,686629,1034922,371784,433817,143087,309462,720896,363174,1046857,965659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 603211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 603211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]