SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.007488s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 271012 LIMIT 1 [ RunTime:0.010115s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 271012 [ RunTime:0.006227s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18092,250522,219812,377266,878323,932410,457038,759393,284601,72949,340015,344010,452094,927172,327157,363696,1026478,280312,381955,44326,595747,300287,27429,512268,214463,128153,640867,371327,497271,13982,620742,967433,37911,210771,498138,988890,960060,676421,162416,113875,679624,596417,741324,243865,1034648,512420,1008316,761207,952909,481546,456422,890180,315178,339479,918865,974534,394341,536122,599393,207568) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 271012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.007386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 271012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005317s ]