SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 295091 LIMIT 1 [ RunTime:0.000516s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 295091 [ RunTime:0.001879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (875471,593661,742968,116686,818895,675166,586347,830948,108455,51101,155681,749135,1024107,387257,541845,799256,115241,122164,289107,16555,548726,192411,738704,52405,106471,115255,388310,887727,903784,1001721,619248,537862,58914,1015777,418638,98771,470438,267631,995704,326974,157380,291609,15224,41876,602983,499269,479624,26683,608962,971946,367544,161655,51875,566254,441590,989209,738958,504727,703032,400042) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 295091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 295091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]