SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 395475 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 395475 [ RunTime:0.001738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (964141,182412,1002059,175396,109504,384995,115993,653230,192617,685814,452230,509965,98759,85810,394345,774721,514408,27834,135714,627002,669983,713679,18014,638644,300271,670643,981561,822813,504807,945570,933626,763479,490045,840738,491167,244151,958072,440661,627400,304735,1022817,360619,198234,795004,119090,834425,956445,815203,214838,18923,351424,361937,28863,481611,38840,822985,894432,526488,775159,495483) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 395475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 395475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]