SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412814 LIMIT 1 [ RunTime:0.001005s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412814 [ RunTime:0.001798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (651099,824137,218330,414366,593697,102755,29786,906466,850481,100173,414097,348424,238521,967860,408154,203373,799862,641006,671017,348474,242586,308441,697494,166173,639679,835586,807882,195788,595383,280823,621842,634437,487499,305698,626761,815834,566844,665292,579093,31193,622063,938258,601492,393800,650085,322959,799813,719040,723919,176806,843822,929387,716499,290209,405532,124072,763852,413545,343390,1258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001863s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]