SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804813 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804813 [ RunTime:0.002169s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (714975,171808,235104,366731,763915,564960,138823,886333,676373,630389,387694,50836,1013314,58782,896228,959650,93190,609585,676126,924298,501594,591647,218313,275690,400143,847692,139381,734406,439462,628782,371550,588686,806598,12153,932373,40610,906764,446524,174642,214846,801983,80599,199334,778391,1005117,153759,898278,137546,492277,880864,552003,176021,128253,331680,411146,50860,559181,12426,731707,382834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]