SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534027 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534027 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (153252,704352,937486,124902,796373,519404,74219,774786,213046,385144,869710,400335,268013,1031188,562602,893682,1030667,186029,217710,289237,603481,422648,61595,45231,669468,761116,223136,419123,119354,502855,834486,465017,426218,794093,186402,749525,810184,540537,329203,29856,569889,256141,108692,321376,113300,861649,847970,603839,581573,316426,1001637,915657,877758,821510,873387,427132,656544,523829,762729,824568) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]