SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007398 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007398 [ RunTime:0.001834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417396,499758,993576,921625,562823,1009669,590408,1021046,196463,651344,425068,630800,382611,824928,998774,70521,976411,769696,1025474,783367,351776,44550,27866,384186,909063,284101,501924,577122,138179,480156,420161,832562,546918,22501,768396,655549,960650,343906,213856,416559,634602,943185,943905,873152,625135,467195,592377,657322,962549,308108,810647,923686,369219,981776,67959,1008033,29609,673695,954593,502057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]