SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319485 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319485 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402038,58774,302598,491451,810048,912962,988210,734721,959763,455595,180245,893168,521227,979352,253955,119356,629694,429635,1011042,447989,1001980,590276,75929,32079,401287,918283,871325,702389,976515,231748,875187,335291,560392,28768,112978,955661,710833,167974,1000714,779129,844861,506930,559647,157471,940789,145269,369162,470886,66389,169518,651447,358458,331588,14601,560336,424551,450127,380895,839893,142408) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001724s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319485 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319485 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]