SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305321 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305321 [ RunTime:0.001653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629376,809615,556911,673549,1047938,767520,580327,87828,522676,205591,351442,394528,802363,396454,807898,669108,292088,412575,328281,745331,121852,526125,1024551,3131,110385,993395,746513,16679,999826,838834,233983,522238,357490,359075,996718,65036,307021,460395,165160,470862,369908,930312,150102,808788,412948,357762,319111,94122,380370,346274,67000,884463,481597,892600,464339,540752,899655,89525,387234,91393) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305321 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305321 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]