SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 231083 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 231083 [ RunTime:0.001497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (131368,713993,69126,188147,628980,205021,394566,39771,773793,362185,512213,759013,142421,560881,218038,887145,552176,496535,250057,407718,400054,76350,467121,695073,222731,100229,245511,819085,77376,363925,659902,536211,190930,334902,905714,531809,320484,195465,264398,929957,254050,654134,723726,360202,119101,378482,447333,546443,680715,771092,188486,240783,390399,620925,841274,467289,351108,479834,829567,248560) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 231083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 231083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]