SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267622 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267622 [ RunTime:0.001501s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (296700,278830,1036020,429159,102032,816434,1025888,127958,392910,214653,166692,186392,469954,446731,906362,713328,771948,504361,409708,361632,270523,563999,146439,980063,122411,217202,24330,353245,817743,755566,884558,416782,831096,304523,684036,430190,420756,651297,754450,625911,429674,911296,610165,330894,445032,461092,55407,887307,484720,856341,982010,476566,1023227,640683,410366,852998,506783,301471,525048,893284) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267622 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267622 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001480s ]