SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200402 LIMIT 1 [ RunTime:0.004854s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200402 [ RunTime:0.002233s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (887019,3010,848616,622214,65777,379391,722088,200586,385111,594004,11234,618343,343039,965625,367859,538822,950131,1022194,285326,389320,656429,724919,488252,328596,434507,608340,274187,197198,635446,2300,976082,676201,207084,855389,522170,82678,87928,991006,934725,834362,48286,659284,407282,276006,845226,67222,408420,276279,116719,595242,84670,1014094,354997,691497,1034875,489064,920658,222088,320315,293016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200402 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200402 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002631s ]