SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498522 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498522 [ RunTime:0.002599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123268,609456,165624,240226,106360,77852,821311,551732,190030,812238,294000,552781,726466,909466,284665,1044230,648954,477125,266961,846466,170216,187153,375835,150641,547171,437480,541062,849623,138813,634558,371361,964013,566408,922634,553396,826834,681267,831414,807731,156557,971300,630065,141007,38959,543540,170333,303967,184137,1002318,233555,470601,549621,751200,301904,462628,963514,696069,466869,752622,556580) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]