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` = 55580 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 55580 [ RunTime:0.003140s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580531,655180,593186,191728,289915,631228,66819,716486,765507,446624,384367,326175,900400,322799,320301,38063,990603,555455,202236,633057,907188,953887,108096,74866,585860,693839,948780,390053,688100,670141,125342,520754,66928,440165,357055,683744,640722,721797,1048029,896227,163292,1035237,955028,189974,510957,91302,708726,173607,223980,1006032,477192,455171,608071,114747,980192,571941,797067,907410,954887,763375) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.024906s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 55580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 55580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]