SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001934s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026502 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026502 [ RunTime:0.001614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250932,104538,897964,2271,245854,184075,252006,700640,1000349,673512,995444,760359,266021,778339,20204,461029,63740,1005704,945941,256353,396461,505465,616850,896370,830400,547091,212602,832394,43977,72680,238240,613461,835445,467564,256511,266366,481385,10172,205886,986216,149116,304261,282919,357924,902721,139036,878050,65453,373616,725566,303920,73606,138909,840242,98649,784551,324113,1015156,739716,3057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026502 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026502 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]