SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001626s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438584 LIMIT 1 [ RunTime:0.000469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438584 [ RunTime:0.001971s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (565969,1001278,43767,188997,951771,853829,344148,628502,845358,52635,807300,327904,353434,29206,963790,770359,616894,493147,1027588,390201,199898,47393,661734,225632,729979,14856,228274,173700,512898,835053,682678,777700,527206,470813,80759,479373,61983,771476,770011,544879,898130,385859,548693,502886,575556,619231,1012691,978239,972026,642818,321129,611171,218347,137213,158202,897409,174591,744014,210430,441706) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001513s ]