SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438610 LIMIT 1 [ RunTime:0.000507s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438610 [ RunTime:0.001815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030988,625730,852831,5015,734192,423109,714727,891721,136410,129728,472201,1020387,704984,283294,787898,443110,70757,362067,171207,996588,483569,145905,534828,727244,51682,673351,209428,48594,610864,889178,592801,189000,294978,316720,952821,920964,220241,137509,6058,663635,245112,517294,303538,509676,878021,449955,1027734,482822,298185,106122,879653,969658,987598,380379,970530,364696,670847,911827,501743,11577) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]