SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380917 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380917 [ RunTime:0.001858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (467871,804513,191562,852868,409124,461380,120535,716378,248841,410053,10856,490828,91725,758857,209377,836772,313663,145420,72206,881867,868723,308385,141982,82792,110617,703288,743959,294016,446751,127367,300723,589363,430120,752047,901267,220305,531406,624841,915314,370813,961034,453163,104223,245016,963369,579690,401662,586639,924065,25995,88840,222182,1000612,55924,953720,412165,407805,926857,641330,795215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]