SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 641718 LIMIT 1 [ RunTime:0.000558s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 641718 [ RunTime:0.002782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40194,596469,476405,364536,562201,183734,832881,795697,445852,20146,77837,204708,994714,755834,399318,1047534,340065,46117,228577,648013,374922,630496,754591,699410,95002,52424,263422,602066,910243,1042591,173795,462432,544904,278227,1028800,1036313,299088,381798,401400,56443,922677,755838,686503,206390,849778,603414,894045,551996,131354,220061,1024912,14422,132571,898692,436573,48397,1019590,208114,827035,185897) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 641718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 641718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]