SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028504 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028504 [ RunTime:0.002568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (79554,706849,785928,683448,157647,205359,73853,675793,312712,549639,659043,791174,623410,194136,223166,490520,170486,346982,337915,516418,700307,921558,258444,873316,586402,116661,7188,372404,337815,801241,223637,933679,689558,445001,460868,241885,392270,866334,426384,881214,854586,496559,389576,705022,222491,500658,282079,525887,899902,108650,716338,46071,567195,405488,23963,206063,617787,922351,573232,346787) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000716s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]