SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479281 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479281 [ RunTime:0.002076s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (855078,345458,40015,787734,524980,921149,973328,54759,199867,932144,1015140,736189,780526,766101,147057,471290,950767,483964,918092,252912,757615,274280,429980,631309,597449,550065,938009,401345,1016984,44137,364552,469126,597276,781854,194065,873036,124212,346801,932459,753973,22574,1007111,522591,805433,844863,823049,479350,529221,69938,630397,90296,17062,146599,365066,1041781,971775,987178,292541,1045220,428833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]