SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457310 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457310 [ RunTime:0.003566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (693113,221777,1026109,129523,914977,904489,786100,883628,310464,343721,476579,337788,37421,779617,829907,205367,444852,1019507,866602,98150,445681,50253,919733,1002183,721169,396724,147665,263190,844791,802609,284562,719296,976866,414181,949037,796571,49677,299313,705662,581936,247204,739237,786570,984777,462718,979424,732543,16553,660158,336939,755969,164853,7282,772918,944834,749632,605033,938869,949794,707311) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]