SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020272 LIMIT 1 [ RunTime:0.000289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020272 [ RunTime:0.001919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384609,187885,30420,333270,612225,633835,840671,852896,496424,878044,1033296,458054,926705,998018,136596,86689,171569,798816,1040044,264075,157194,157872,161288,652194,104559,560852,590979,442441,720991,791747,631696,990292,588452,346367,526325,196786,1007792,1004682,247024,51485,849198,496356,22886,122321,192560,1024788,967223,699700,908865,884041,73931,800426,25890,820722,593262,362678,396441,807213,60135,899969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020272 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020272 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]