SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281975 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281975 [ RunTime:0.001993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (329245,369534,424046,790562,700777,546052,1014090,310230,412381,893325,636691,754923,441250,697388,938008,241922,837932,987393,580960,380561,450100,728246,504320,758602,632965,696794,623151,706728,918848,1025107,387206,1019637,818025,563297,333177,210115,1005210,586498,242707,780100,301986,794058,765655,239656,376408,228228,220754,3943,1000664,354831,88164,447409,998226,151402,427634,993267,391602,597012,380261,504464) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001680s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281975 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281975 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000846s ]