SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003805s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50270 LIMIT 1 [ RunTime:0.005446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50270 [ RunTime:0.003732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (188272,350980,890141,107013,748400,390326,509182,80186,717808,544656,626412,136141,301478,826240,192105,115963,975685,359076,970347,814677,533589,666968,91838,260651,151017,168410,711242,707616,409291,687998,664891,966165,730595,611376,279398,63558,712245,556979,38800,131335,11300,129762,588396,303936,822528,496074,925061,832227,259821,662678,726810,977981,900003,600522,100317,317787,57373,876606,265305,76137) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50270 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50270 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]