SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103430 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103430 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (673968,32199,823308,455498,265410,145952,591870,518191,532310,312977,808186,281479,551678,841709,236479,1013180,716860,722420,666058,598587,873689,844407,371360,643420,328358,81762,68951,42712,651043,908174,452926,312579,939525,270162,39233,70314,1035696,487560,977317,781767,518095,141939,396643,990123,353435,1031802,833424,825549,368698,824813,892323,709265,1016631,174161,441566,965030,648634,501025,772024,884560) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103430 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103430 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]