SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410454 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410454 [ RunTime:0.001599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (799195,1025470,42340,391489,38169,292075,493615,968197,974777,44971,211822,773073,588394,774200,28069,256731,396407,435305,514885,948449,104124,905299,840178,759714,231775,1004353,454825,409467,298943,745906,905350,109699,4169,233492,430446,346836,969090,707868,837739,381071,955495,607473,721957,532650,303795,343745,174166,671603,277418,880579,550830,322571,119865,188881,867699,236599,866060,717153,550935,656607) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410454 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410454 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]