SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421590 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421590 [ RunTime:0.002710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (7760,418389,105369,470929,322170,473889,147371,686551,736337,281572,225049,70123,610845,602354,1008245,200495,666677,260273,74840,747372,681593,689689,183857,195245,347945,840813,545413,135332,490165,297196,847604,831860,348541,127697,436560,283638,419045,294370,310456,381333,267721,218841,203000,831736,334544,196638,935521,429661,767332,992928,905620,432363,129135,54719,225682,239255,17865,662646,49735,538565) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421590 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421590 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]