SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100106 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100106 [ RunTime:0.001903s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (907839,332087,810000,569237,1015626,277149,252717,234309,642214,762270,228412,876455,531943,1029036,804642,18616,982347,201586,39002,1039029,259151,967341,554115,317112,242406,522349,616107,164961,402986,164121,973941,995953,839359,288094,720817,726554,724610,81213,361902,227780,796060,446961,788140,60827,44682,311634,691837,1006388,1046937,1047154,699833,473416,49626,266727,386826,849674,744432,774290,648750,242301) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]