SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001655s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 315718 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 315718 [ RunTime:0.001513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (817373,570448,447632,200090,1006306,824816,507897,149212,575248,281085,50996,158630,965382,699117,970094,168547,369313,633751,180229,849174,655394,367683,440882,223921,981079,519964,997900,132499,651907,182450,821721,708835,839013,420616,59002,230425,157627,528090,1005116,317246,729417,626343,589511,844234,888508,24975,633373,296369,801263,602965,91295,828429,203191,90597,969904,197419,321981,471304,490513,477622) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001913s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 315718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001859s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 315718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001155s ]