SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442181 LIMIT 1 [ RunTime:0.001046s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442181 [ RunTime:0.003537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (816537,125099,954167,27573,481002,19538,557476,109345,1016693,32466,200,808623,855771,1014653,676002,451693,920501,269253,397951,327652,230056,220625,518044,613211,174674,157507,174010,508223,746689,961682,882313,870825,358390,203998,299312,532804,71147,100014,834284,1039641,205364,213911,490907,430190,547850,85073,992518,23563,761235,944604,759705,153632,845601,2572,102122,820147,459495,902957,914134,403981) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.018325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000613s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001129s ]