SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001512s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012267 LIMIT 1 [ RunTime:0.001124s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012267 [ RunTime:0.002926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (764734,1018101,661863,1035069,762077,784333,725135,1042729,517089,695205,828255,1024884,548926,653556,57717,888650,622785,47938,32095,293846,315835,909055,152216,675349,1045190,972930,817702,39161,621666,427742,13000,232388,554273,102131,150744,910183,227645,93725,1023622,952380,869645,874281,143644,479122,619358,341422,401823,119670,682844,853529,388878,243575,348585,225668,316322,339830,791926,415985,612030,422338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012267 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012267 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]