SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 228571 LIMIT 1 [ RunTime:0.000496s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 228571 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (14180,427029,173277,953444,785373,66326,481802,759457,233771,1043668,364812,479324,664389,572671,729683,665904,256859,1022191,348583,825210,676995,468304,363034,749466,503615,264045,249333,712281,531154,862763,211250,320239,610195,420050,1000578,835960,186027,609764,913951,140570,444356,1005753,1029365,30752,1021198,985850,477150,355118,72418,370196,865851,688623,236617,609330,115890,377191,479311,334022,996440,944810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 228571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 228571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]