SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501020 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501020 [ RunTime:0.001989s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (615034,510090,642378,3473,411381,1028553,435130,763501,63437,469896,958039,134784,987399,561456,509612,548093,600241,111956,407639,712222,151530,601134,1012667,593866,323843,932112,56935,529329,797061,411380,371649,1028043,889366,647065,985409,878570,669797,801382,101824,74457,330996,733677,235403,94162,509044,844957,515650,758041,947094,988886,42399,953355,744888,129236,633899,515804,312049,464610,637862,701244) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]