SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106226 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106226 [ RunTime:0.001510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (13030,820013,691717,1038077,89887,229311,253812,337908,132573,266936,914767,881707,190165,464366,73568,242161,879742,36661,574185,507033,566838,431420,262602,613275,140957,264769,736661,873853,94880,1020313,794654,296849,662008,736673,142143,439028,958640,894700,174739,989682,770982,361301,714981,897662,861538,967889,308546,595164,102606,441970,1002049,477340,473083,432642,56088,892572,669506,400331,1019663,1042970) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000394s ]