SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000141 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000141 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311956,683866,348019,675283,737254,419393,797836,339228,887901,357260,126960,773800,329403,782672,1042876,394627,93728,689662,229536,250225,347284,171079,776442,202374,425603,697015,244023,981177,185132,840722,698465,760119,883091,105252,360209,837375,174254,698724,540602,890983,448659,130927,336775,907915,389257,697385,134327,708865,125897,332083,615630,305681,499861,625446,983548,647484,446201,30629,259984,579083) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]