SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001857s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320708 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320708 [ RunTime:0.002186s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4875,352326,183158,436128,109230,910772,34762,151109,1028451,15973,73147,442886,805859,452265,478531,1008433,554215,189261,1036323,862094,561618,938289,11513,611004,383933,310103,353808,428900,283500,778920,712856,390250,361368,927339,370982,949859,529156,648569,639248,399640,354884,975476,243757,576874,482968,595235,449275,603649,1044679,676834,894517,657677,167083,765899,396346,687763,432242,179165,505819,500508) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]