SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006629s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104762 LIMIT 1 [ RunTime:0.001944s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104762 [ RunTime:0.002377s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (973409,756027,106105,122033,731568,297442,602375,794867,658710,969232,492501,457110,832869,688052,528624,662410,134592,982260,677284,765157,1034111,316035,448546,364968,411895,797961,732462,257137,623088,493152,1005210,8463,276440,211032,1039384,611941,1083,86251,940238,230470,713479,833943,291445,871042,978292,533430,406146,295620,577505,392826,893855,112988,311708,96167,875935,899375,111912,407263,395986,72180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001735s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104762 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104762 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003797s ]