SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001456s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534056 LIMIT 1 [ RunTime:0.003567s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534056 [ RunTime:0.002024s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (358124,168103,135456,493758,752390,6115,977278,823586,529017,20124,530777,49015,846528,220242,901106,979650,192921,682546,492821,388765,519420,145074,640384,848464,1016879,175485,453285,462233,967622,903288,22328,354137,609324,1036007,630055,713999,536948,283420,198316,565221,839260,767264,264098,309332,214955,295637,364208,219142,1024561,594409,599941,944646,743187,267591,857083,507328,20968,833370,306125,348949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534056 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534056 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]