SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009243 LIMIT 1 [ RunTime:0.000545s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009243 [ RunTime:0.002160s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (555208,58931,923479,793942,122268,1036502,583242,415140,996494,518062,60116,260429,741366,906015,509145,295463,489193,217962,389103,948605,109350,629483,281757,291960,624600,668524,758287,619772,256217,13098,252233,6263,773717,1010955,750355,880212,450117,124611,702781,851445,673026,501030,738212,390492,129946,154069,920407,366953,950087,308384,415640,692476,10683,1038327,497643,123596,617867,1039276,542758,192078) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]