SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 628301 LIMIT 1 [ RunTime:0.000529s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 628301 [ RunTime:0.003175s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480743,54520,497762,494238,84430,964577,483621,50370,842158,596632,700019,240408,938132,8252,252474,913590,538400,746248,504786,66787,639836,702281,66916,637300,148789,725427,106096,900690,391948,1015295,264474,890039,52902,389201,32727,166211,808565,514200,351931,254538,873240,380884,902858,867656,420747,729145,828160,336432,208946,210379,498436,353566,399788,545673,813262,658867,214182,896765,342093,636653) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 628301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 628301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004545s ]