SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312181 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312181 [ RunTime:0.001485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (926421,52650,233105,265982,624447,592435,735420,930935,650776,1008014,672156,46297,157804,98853,580939,604065,829164,1028693,783100,322687,144866,1027739,938101,474480,368112,482078,118144,78797,574070,774596,1703,403563,958993,389622,489186,1036495,977,915014,342775,984076,1018313,179408,107454,376091,150483,989202,35000,549165,579878,1009769,611223,753416,664226,936234,581799,1014333,924233,752961,517370,46061) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]