SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001400s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505959 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505959 [ RunTime:0.002842s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009990,656678,674417,177537,355204,508574,525598,141942,791269,221691,318551,529632,969390,858936,645640,510491,593065,469746,804470,661000,726501,851987,538412,294045,344834,683351,4269,288114,793260,109298,215861,479946,431378,648647,114996,158834,578553,669359,970264,471123,735975,590240,406983,673691,319911,529586,458780,840805,974175,347163,230398,211577,700885,213543,602788,940839,1030971,877930,457922,978110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505959 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505959 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]