SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805748 LIMIT 1 [ RunTime:0.000477s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805748 [ RunTime:0.002252s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413118,513482,380183,540528,1027182,752246,668229,448016,796939,20733,452392,875397,885911,438769,127434,835668,758821,936384,307186,966818,942005,762339,941572,727916,350975,539744,378669,951091,392605,707440,852335,93860,1048238,643600,626204,240678,593638,909422,855053,11592,57438,195307,47194,784621,8625,1001493,385358,467126,366807,834707,125072,203342,670810,247850,720116,958766,343730,1023880,733083,596867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]