SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000898s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458801 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458801 [ RunTime:0.003229s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251862,454380,808509,976431,411015,80639,106890,408177,480496,443026,660588,454556,1039628,74751,435240,221106,338802,910199,57281,711878,893331,28750,982639,288341,157377,744665,10609,319816,727337,985196,226799,259457,324961,358524,1036021,291638,353784,774574,456326,1014346,645694,348088,428788,689425,392860,818939,295089,435213,489443,658869,88440,567003,641339,513206,500481,196968,57092,257869,540052,277203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]