SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500683 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500683 [ RunTime:0.001619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295632,366849,598765,252642,533592,1046516,762601,719119,346095,868223,792012,463536,701110,238634,173692,416348,545246,133677,784510,74164,271058,236079,733081,485643,177582,911136,164997,332662,320096,981439,351350,259109,203444,901537,398951,831789,552284,183326,228090,225293,244821,497433,173078,736562,294381,273572,115352,502522,881460,873655,462687,90493,18748,901842,305622,918379,1031256,672655,240045,523599) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]