SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200345 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200345 [ RunTime:0.003419s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480874,291644,72064,626437,89072,220017,400061,467207,706295,849751,10235,731432,754917,986186,969562,825646,940669,663609,371704,708317,434542,589017,634306,89749,126509,529178,932196,189714,929380,584385,831027,928212,881453,547596,666372,44401,172724,302618,946979,862305,675541,231560,223608,54271,113690,489767,702863,63869,141601,335642,334042,701040,141943,177681,492092,715003,977860,505708,39240,764626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200345 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200345 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]