SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018939 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018939 [ RunTime:0.002848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (733543,988930,490301,81005,997194,169797,299893,580390,1037360,673072,956946,830906,787780,169804,54808,330391,186191,368130,210211,830070,873487,970507,569203,217637,206527,805574,983342,64415,66890,832423,642817,709389,735176,106897,932263,292555,194514,619819,513877,712893,581998,859671,159135,124977,943384,878977,673768,254726,766205,830190,378344,182931,252933,517602,97292,836981,831054,523275,645027,302883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018939 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018939 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]